{smcl}
{com}{sf}{ul off}{txt}{.-}
      name:  {res}<unnamed>
       {txt}log:  {res}C:\Users\gk57526\Dropbox\DISCRIMINATION PROJECT (U.S. FEDERAL AGENCIES)\Organizational Diversity & Formal Complaints Project\Statistics\Krause & Park.Authority Differentials.APPENDIX J RESULTS.11-24-2023.smcl
  {txt}log type:  {res}smcl
 {txt}opened on:  {res}24 Nov 2023, 17:30:12
{txt}
{com}. 
.   
.   
. 
. **** "STATUS GROUP DIFFERENTIALS AS REFERENCE POINTS FOR FOSTERING DIVERSITY AND INCLUSION WITHIN THE U.S. FEDERAL CIVILIAN WORKFORCE" [KRAUSE & PARK, NOVEMBER 2023] ****
. 
. 
. 
. **** APPENDIX J: EVALUATING POTENTIAL SOCIAL DESIRABILITY BIAS IN EMPLOYEE RESPONDENT D & I EVALUATIONS ***
. 
. 
. 
. 
. *** ACCESS DATABASE FOR THE PROJECT: FEVS DATA FROM 2010-2019 AND 'MATCHED' OPM DATA: POST-ESTIMATION OF MANUSCRIPT RESULTS ****
. 
. 
. use "C:\Users\gk57526\Dropbox\DISCRIMINATION PROJECT (U.S. FEDERAL AGENCIES)\Organizational Diversity & Formal Complaints Project\Statistics\2010-2019_DATA FINAL.11-22-2023.GAK.post-estimation.dta", replace   
{txt}
{com}. 
.  
. ******************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************
. ******************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************
. ******************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************
. ******************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************
. ******************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************
. *****************************************************************************************************************************************************************************************
. 
. 
. 
. 
. ****** DIFFERENCES IN MEANS (T) TEST *******
. 
. *** TERCILE GROUPINGS BASED ON EFFECTIVE SAMPLE OF OPBSERVATIONS COVERED IN THE REGRESSION MODELS [N = 2,507,103] ***
. 
. 
. 
. quietly regress lndiversity2zeroadj  c.ln_ratio_fmsup_fmsub##i.gender   ln_ratio_fem_tot_men_tot   minority  supervisor  topoffgender_2 lntotworkforce_count  ln_professionals_total_ratio i.agencyid i.year , vce(cluster agencyid)
{txt}
{com}. *
. estat ic

{txt}Akaike's information criterion and Bayesian information criterion

{hline 13}{c TT}{hline 63}
       Model {c |}          N   ll(null)  ll(model)      df        AIC        BIC
{hline 13}{c +}{hline 63}
{ralign 12:.}{col 14}{c |}{res}{col 16} 2,507,103{col 28} -1943049{col 39} -1891389{col 50}    18{col 58}  3782815{col 69}  3783044
{txt}{hline 13}{c BT}{hline 63}
{p 0 6 0 77}Note: BIC uses N = number of observations. See {helpb bic_note:{bind:[R] IC note}}.{p_end}

{com}. *
. *
. *
. 
. _pctile  ln_ratio_fmsup_fmsub if e(sample), p(33.33, 66.67)
{txt}
{com}. return list

{txt}scalars:
                 r(r1) =  {res}-.4131458103656769
                 {txt}r(r2) =  {res}-.2619786560535431
{txt}
{com}. *
. _pctile  ln_ratio_mnmsup_mnmsub if e(sample), p(33.33, 66.67)
{txt}
{com}. return list

{txt}scalars:
                 r(r1) =  {res}-.3859817981719971
                 {txt}r(r2) =  {res}-.286034494638443
{txt}
{com}. 
. 
. ******************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************
. 
. 
. 
. 
. *** WOMEN versus MEN Respondent Differences: Relative SGPDs [AUTHORITY DIFFERENTIALS -- SEE EQUATION (1)] ***
. 
. 
. ** LOWER TERCILE WOMEN RELATIVE SGPDs [ln_ratio_fmsup_fmsub < -0.4131458103656769] ** 
. ttest lndiversity2zeroadj if ln_ratio_fmsup_fmsub < -0.4131458103656769, by(gender) unequal reverse

{txt}Two-sample t test with unequal variances
{hline 9}{c TT}{hline 68}
   Group{col 10}{c |}{col 16}Obs{col 27}Mean{col 35}Std. err.{col 47}Std. dev.{col 59}[95% conf. interval]
{hline 9}{c +}{hline 68}
       1 {c |}{res}{col 12}378,218{col 22} .6372567{col 34}  .000919{col 46} .5651526{col 58} .6354555{col 70} .6390578
       {txt}0 {c |}{res}{col 12}452,444{col 22} .7037379{col 34} .0007226{col 46} .4860396{col 58} .7023217{col 70} .7051542
{txt}{hline 9}{c +}{hline 68}
Combined {c |}{res}{col 12}830,662{col 22} .6734676{col 34} .0005756{col 46} .5245914{col 58} .6723395{col 70} .6745957
{txt}{hline 9}{c +}{hline 68}
    diff {c |}{res}{col 22}-.0664813{col 34}  .001169{col 58}-.0687725{col 70}  -.06419
{txt}{hline 9}{c BT}{hline 68}
    diff = mean({res}1{txt}) - mean({res}0{txt})                                      t = {res}-56.8692
{txt}H0: diff = 0                     Satterthwaite's degrees of freedom = {res}  750622

    {txt}Ha: diff < 0                 Ha: diff != 0                 Ha: diff > 0
 Pr(T < t) = {res}0.0000         {txt}Pr(|T| > |t|) = {res}0.0000          {txt}Pr(T > t) = {res}1.0000
{txt}
{com}. 
. ** MIDDLE TERCILE WOMEN RELATIVE SGPDs [ln_ratio_fmsup_fmsub >= -0.4131458103656769 & ln_ratio_fmsup_fmsub < -0.2619786560535431] ** 
. ttest lndiversity2zeroadj if ln_ratio_fmsup_fmsub >= -0.4131458103656769 & ln_ratio_fmsup_fmsub < -0.2619786560535431, by(gender) unequal reverse

{txt}Two-sample t test with unequal variances
{hline 9}{c TT}{hline 68}
   Group{col 10}{c |}{col 16}Obs{col 27}Mean{col 35}Std. err.{col 47}Std. dev.{col 59}[95% conf. interval]
{hline 9}{c +}{hline 68}
       1 {c |}{res}{col 12}331,436{col 22} .6492509{col 34} .0009642{col 46} .5550823{col 58} .6473611{col 70} .6511406
       {txt}0 {c |}{res}{col 12}491,292{col 22} .7015387{col 34} .0007078{col 46} .4961428{col 58} .7001513{col 70}  .702926
{txt}{hline 9}{c +}{hline 68}
Combined {c |}{res}{col 12}822,728{col 22} .6804745{col 34} .0005747{col 46} .5213205{col 58}  .679348{col 70}  .681601
{txt}{hline 9}{c +}{hline 68}
    diff {c |}{res}{col 22}-.0522878{col 34} .0011961{col 58}-.0546321{col 70}-.0499435
{txt}{hline 9}{c BT}{hline 68}
    diff = mean({res}1{txt}) - mean({res}0{txt})                                      t = {res}-43.7148
{txt}H0: diff = 0                     Satterthwaite's degrees of freedom = {res}  656351

    {txt}Ha: diff < 0                 Ha: diff != 0                 Ha: diff > 0
 Pr(T < t) = {res}0.0000         {txt}Pr(|T| > |t|) = {res}0.0000          {txt}Pr(T > t) = {res}1.0000
{txt}
{com}. 
. ** UPPER TERCILE WOMEN RELATIVE SGPDs [ln_ratio_fmsup_fmsub >= -0.2619786560535431] ** 
. ttest lndiversity2zeroadj if ln_ratio_fmsup_fmsub >= -0.2619786560535431, by(gender) unequal reverse

{txt}Two-sample t test with unequal variances
{hline 9}{c TT}{hline 68}
   Group{col 10}{c |}{col 16}Obs{col 27}Mean{col 35}Std. err.{col 47}Std. dev.{col 59}[95% conf. interval]
{hline 9}{c +}{hline 68}
       1 {c |}{res}{col 12}402,419{col 22} .6746683{col 34} .0008686{col 46} .5509995{col 58} .6729659{col 70} .6763707
       {txt}0 {c |}{res}{col 12}451,294{col 22} .7164152{col 34} .0007568{col 46} .5084005{col 58} .7149319{col 70} .7178985
{txt}{hline 9}{c +}{hline 68}
Combined {c |}{res}{col 12}853,713{col 22} .6967368{col 34} .0005729{col 46} .5293183{col 58}  .695614{col 70} .6978596
{txt}{hline 9}{c +}{hline 68}
    diff {c |}{res}{col 22}-.0417469{col 34}  .001152{col 58}-.0440048{col 70}-.0394889
{txt}{hline 9}{c BT}{hline 68}
    diff = mean({res}1{txt}) - mean({res}0{txt})                                      t = {res}-36.2377
{txt}H0: diff = 0                     Satterthwaite's degrees of freedom = {res}  822598

    {txt}Ha: diff < 0                 Ha: diff != 0                 Ha: diff > 0
 Pr(T < t) = {res}0.0000         {txt}Pr(|T| > |t|) = {res}0.0000          {txt}Pr(T > t) = {res}1.0000
{txt}
{com}. 
. 
. 
. 
. ************** BROKEN DOWN BY NON-SUPERVISORY RESPONDENTS AND SUPERVISORY RESPONDENTS **************
. 
. 
. 
. ************** NON-SUPERVISORY RESPONDENTS **************
. 
. 
. ** LOWER TERCILE WOMEN RELATIVE SGPDs [ln_ratio_fmsup_fmsub < -0.4131458103656769] ** 
. ttest lndiversity2zeroadj if ln_ratio_fmsup_fmsub < -0.4131458103656769 & supervisor == 0, by(gender) unequal reverse

{txt}Two-sample t test with unequal variances
{hline 9}{c TT}{hline 68}
   Group{col 10}{c |}{col 16}Obs{col 27}Mean{col 35}Std. err.{col 47}Std. dev.{col 59}[95% conf. interval]
{hline 9}{c +}{hline 68}
       1 {c |}{res}{col 12}304,148{col 22} .6112353{col 34} .0010628{col 46} .5861519{col 58} .6091522{col 70} .6133184
       {txt}0 {c |}{res}{col 12}315,946{col 22} .6671032{col 34}  .000923{col 46} .5188292{col 58}  .665294{col 70} .6689123
{txt}{hline 9}{c +}{hline 68}
Combined {c |}{res}{col 12}620,094{col 22} .6397007{col 34}  .000703{col 46}   .55358{col 58} .6383229{col 70} .6410786
{txt}{hline 9}{c +}{hline 68}
    diff {c |}{res}{col 22}-.0558679{col 34} .0014077{col 58}-.0586269{col 70}-.0531088
{txt}{hline 9}{c BT}{hline 68}
    diff = mean({res}1{txt}) - mean({res}0{txt})                                      t = {res}-39.6873
{txt}H0: diff = 0                     Satterthwaite's degrees of freedom = {res}  604772

    {txt}Ha: diff < 0                 Ha: diff != 0                 Ha: diff > 0
 Pr(T < t) = {res}0.0000         {txt}Pr(|T| > |t|) = {res}0.0000          {txt}Pr(T > t) = {res}1.0000
{txt}
{com}. 
. ** MIDDLE TERCILE WOMEN RELATIVE SGPDs [ln_ratio_fmsup_fmsub >= -0.4131458103656769 & ln_ratio_fmsup_fmsub < -0.2619786560535431] ** 
. ttest lndiversity2zeroadj if ln_ratio_fmsup_fmsub >= -0.4131458103656769 & ln_ratio_fmsup_fmsub < -0.2619786560535431 & supervisor == 0, by(gender) unequal reverse

{txt}Two-sample t test with unequal variances
{hline 9}{c TT}{hline 68}
   Group{col 10}{c |}{col 16}Obs{col 27}Mean{col 35}Std. err.{col 47}Std. dev.{col 59}[95% conf. interval]
{hline 9}{c +}{hline 68}
       1 {c |}{res}{col 12}263,964{col 22} .6218474{col 34} .0011264{col 46} .5786951{col 58} .6196398{col 70} .6240551
       {txt}0 {c |}{res}{col 12}349,925{col 22} .6649955{col 34} .0008966{col 46} .5303869{col 58} .6632382{col 70} .6667529
{txt}{hline 9}{c +}{hline 68}
Combined {c |}{res}{col 12}613,889{col 22} .6464424{col 34} .0007046{col 46} .5520904{col 58} .6450614{col 70} .6478235
{txt}{hline 9}{c +}{hline 68}
    diff {c |}{res}{col 22}-.0431481{col 34} .0014397{col 58}-.0459698{col 70}-.0403264
{txt}{hline 9}{c BT}{hline 68}
    diff = mean({res}1{txt}) - mean({res}0{txt})                                      t = {res}-29.9712
{txt}H0: diff = 0                     Satterthwaite's degrees of freedom = {res}  540703

    {txt}Ha: diff < 0                 Ha: diff != 0                 Ha: diff > 0
 Pr(T < t) = {res}0.0000         {txt}Pr(|T| > |t|) = {res}0.0000          {txt}Pr(T > t) = {res}1.0000
{txt}
{com}. 
. ** UPPER TERCILE WOMEN RELATIVE SGPDs [ln_ratio_fmsup_fmsub >= -0.2619786560535431] ** 
. ttest lndiversity2zeroadj if ln_ratio_fmsup_fmsub >= -0.2619786560535431 & supervisor == 0, by(gender) unequal reverse

{txt}Two-sample t test with unequal variances
{hline 9}{c TT}{hline 68}
   Group{col 10}{c |}{col 16}Obs{col 27}Mean{col 35}Std. err.{col 47}Std. dev.{col 59}[95% conf. interval]
{hline 9}{c +}{hline 68}
       1 {c |}{res}{col 12}324,703{col 22} .6477266{col 34} .0010081{col 46} .5744385{col 58} .6457508{col 70} .6497025
       {txt}0 {c |}{res}{col 12}336,762{col 22} .6853734{col 34} .0009289{col 46} .5390424{col 58} .6835528{col 70}  .687194
{txt}{hline 9}{c +}{hline 68}
Combined {c |}{res}{col 12}661,465{col 22} .6668932{col 34} .0006849{col 46} .5570167{col 58} .6655508{col 70} .6682355
{txt}{hline 9}{c +}{hline 68}
    diff {c |}{res}{col 22}-.0376468{col 34} .0013708{col 58}-.0403335{col 70}-.0349601
{txt}{hline 9}{c BT}{hline 68}
    diff = mean({res}1{txt}) - mean({res}0{txt})                                      t = {res}-27.4635
{txt}H0: diff = 0                     Satterthwaite's degrees of freedom = {res}  654927

    {txt}Ha: diff < 0                 Ha: diff != 0                 Ha: diff > 0
 Pr(T < t) = {res}0.0000         {txt}Pr(|T| > |t|) = {res}0.0000          {txt}Pr(T > t) = {res}1.0000
{txt}
{com}. 
. 
. 
. 
. ************** SUPERVISOR RESPONDENTS **************
. 
. 
. ** LOWER TERCILE WOMEN RELATIVE SGPDs [ln_ratio_fmsup_fmsub < -0.4131458103656769] ** 
. ttest lndiversity2zeroadj if ln_ratio_fmsup_fmsub < -0.4131458103656769 & supervisor == 1, by(gender) unequal reverse

{txt}Two-sample t test with unequal variances
{hline 9}{c TT}{hline 68}
   Group{col 10}{c |}{col 16}Obs{col 27}Mean{col 35}Std. err.{col 47}Std. dev.{col 59}[95% conf. interval]
{hline 9}{c +}{hline 68}
       1 {c |}{res}{col 12} 74,070{col 22} .7441062{col 34} .0016674{col 46} .4537933{col 58} .7408381{col 70} .7473743
       {txt}0 {c |}{res}{col 12}136,498{col 22} .7885348{col 34} .0010471{col 46} .3868754{col 58} .7864825{col 70} .7905872
{txt}{hline 9}{c +}{hline 68}
Combined {c |}{res}{col 12}210,568{col 22} .7729065{col 34} .0008983{col 46}  .412202{col 58} .7711459{col 70} .7746671
{txt}{hline 9}{c +}{hline 68}
    diff {c |}{res}{col 22}-.0444287{col 34} .0019689{col 58}-.0482877{col 70}-.0405696
{txt}{hline 9}{c BT}{hline 68}
    diff = mean({res}1{txt}) - mean({res}0{txt})                                      t = {res}-22.5648
{txt}H0: diff = 0                     Satterthwaite's degrees of freedom = {res}  132807

    {txt}Ha: diff < 0                 Ha: diff != 0                 Ha: diff > 0
 Pr(T < t) = {res}0.0000         {txt}Pr(|T| > |t|) = {res}0.0000          {txt}Pr(T > t) = {res}1.0000
{txt}
{com}. 
. ** MIDDLE TERCILE WOMEN RELATIVE SGPDs [ln_ratio_fmsup_fmsub >= -0.4131458103656769 & ln_ratio_fmsup_fmsub < -0.2619786560535431] ** 
. ttest lndiversity2zeroadj if ln_ratio_fmsup_fmsub >= -0.4131458103656769 & ln_ratio_fmsup_fmsub < -0.2619786560535431 & supervisor == 1, by(gender) unequal reverse

{txt}Two-sample t test with unequal variances
{hline 9}{c TT}{hline 68}
   Group{col 10}{c |}{col 16}Obs{col 27}Mean{col 35}Std. err.{col 47}Std. dev.{col 59}[95% conf. interval]
{hline 9}{c +}{hline 68}
       1 {c |}{res}{col 12} 67,472{col 22} .7564586{col 34} .0016735{col 46} .4346862{col 58} .7531786{col 70} .7597385
       {txt}0 {c |}{res}{col 12}141,367{col 22} .7919936{col 34}  .001022{col 46} .3842633{col 58} .7899905{col 70} .7939968
{txt}{hline 9}{c +}{hline 68}
Combined {c |}{res}{col 12}208,839{col 22} .7805129{col 34} .0008788{col 46} .4015904{col 58} .7787905{col 70} .7822353
{txt}{hline 9}{c +}{hline 68}
    diff {c |}{res}{col 22}-.0355351{col 34} .0019609{col 58}-.0393783{col 70}-.0316918
{txt}{hline 9}{c BT}{hline 68}
    diff = mean({res}1{txt}) - mean({res}0{txt})                                      t = {res}-18.1222
{txt}H0: diff = 0                     Satterthwaite's degrees of freedom = {res}  119268

    {txt}Ha: diff < 0                 Ha: diff != 0                 Ha: diff > 0
 Pr(T < t) = {res}0.0000         {txt}Pr(|T| > |t|) = {res}0.0000          {txt}Pr(T > t) = {res}1.0000
{txt}
{com}. 
. ** UPPER TERCILE WOMEN RELATIVE SGPDs [ln_ratio_fmsup_fmsub >= -0.2619786560535431] ** 
. ttest lndiversity2zeroadj if ln_ratio_fmsup_fmsub >= -0.2619786560535431 & supervisor == 1, by(gender) unequal reverse

{txt}Two-sample t test with unequal variances
{hline 9}{c TT}{hline 68}
   Group{col 10}{c |}{col 16}Obs{col 27}Mean{col 35}Std. err.{col 47}Std. dev.{col 59}[95% conf. interval]
{hline 9}{c +}{hline 68}
       1 {c |}{res}{col 12} 77,716{col 22} .7872328{col 34} .0015121{col 46} .4215278{col 58} .7842692{col 70} .7901964
       {txt}0 {c |}{res}{col 12}114,532{col 22} .8076883{col 34} .0011556{col 46} .3910714{col 58} .8054235{col 70} .8099532
{txt}{hline 9}{c +}{hline 68}
Combined {c |}{res}{col 12}192,248{col 22} .7994192{col 34} .0009209{col 46} .4037839{col 58} .7976142{col 70} .8012242
{txt}{hline 9}{c +}{hline 68}
    diff {c |}{res}{col 22}-.0204555{col 34} .0019031{col 58}-.0241855{col 70}-.0167256
{txt}{hline 9}{c BT}{hline 68}
    diff = mean({res}1{txt}) - mean({res}0{txt})                                      t = {res}-10.7487
{txt}H0: diff = 0                     Satterthwaite's degrees of freedom = {res}  158350

    {txt}Ha: diff < 0                 Ha: diff != 0                 Ha: diff > 0
 Pr(T < t) = {res}0.0000         {txt}Pr(|T| > |t|) = {res}0.0000          {txt}Pr(T > t) = {res}1.0000
{txt}
{com}. 
. 
. 
. 
. 
. 
. 
. 
. 
. 
. *** RACIAL/ETHNIC MINORITY versus RACIAL/ETHNIC NON-MINORITY Respondent Differences: Relative SGPDs  [AUTHORITY DIFFERENTIALS -- SEE EQUATION (1)] ***
. 
. ** LOWER TERCILE MINORITY RELATIVE SGPDs [ln_ratio_mnmsup_mnmsub < -0.3859817981719971] ** 
. ttest lndiversity2zeroadj if ln_ratio_mnmsup_mnmsub < -0.3859817981719971, by(minority) unequal reverse

{txt}Two-sample t test with unequal variances
{hline 9}{c TT}{hline 68}
   Group{col 10}{c |}{col 16}Obs{col 27}Mean{col 35}Std. err.{col 47}Std. dev.{col 59}[95% conf. interval]
{hline 9}{c +}{hline 68}
       1 {c |}{res}{col 12}272,983{col 22} .6124611{col 34} .0011865{col 46} .6199116{col 58} .6101357{col 70} .6147866
       {txt}0 {c |}{res}{col 12}555,054{col 22} .7373966{col 34} .0005985{col 46} .4458751{col 58} .7362236{col 70} .7385696
{txt}{hline 9}{c +}{hline 68}
Combined {c |}{res}{col 12}828,037{col 22} .6962085{col 34}  .000564{col 46} .5132286{col 58} .6951031{col 70}  .697314
{txt}{hline 9}{c +}{hline 68}
    diff {c |}{res}{col 22}-.1249355{col 34} .0013289{col 58}  -.12754{col 70}-.1223309
{txt}{hline 9}{c BT}{hline 68}
    diff = mean({res}1{txt}) - mean({res}0{txt})                                      t = {res}-94.0158
{txt}H0: diff = 0                     Satterthwaite's degrees of freedom = {res}  416308

    {txt}Ha: diff < 0                 Ha: diff != 0                 Ha: diff > 0
 Pr(T < t) = {res}0.0000         {txt}Pr(|T| > |t|) = {res}0.0000          {txt}Pr(T > t) = {res}1.0000
{txt}
{com}. 
. ** MIDDLE TERCILE MINORITY RELATIVE SGPDs [ln_ratio_mnmsup_mnmsub >= -0.3859817981719971 & ln_ratio_mnmsup_mnmsub < -0.286034494638443] ** 
. ttest lndiversity2zeroadj if ln_ratio_mnmsup_mnmsub >= -0.3859817981719971 & ln_ratio_mnmsup_mnmsub < -0.286034494638443, by(minority) unequal reverse

{txt}Two-sample t test with unequal variances
{hline 9}{c TT}{hline 68}
   Group{col 10}{c |}{col 16}Obs{col 27}Mean{col 35}Std. err.{col 47}Std. dev.{col 59}[95% conf. interval]
{hline 9}{c +}{hline 68}
       1 {c |}{res}{col 12}272,274{col 22} .6205648{col 34}    .0012{col 46} .6261409{col 58} .6182129{col 70} .6229167
       {txt}0 {c |}{res}{col 12}570,804{col 22} .7228769{col 34} .0006103{col 46} .4610965{col 58} .7216807{col 70} .7240731
{txt}{hline 9}{c +}{hline 68}
Combined {c |}{res}{col 12}843,078{col 22}  .689835{col 34} .0005689{col 46} .5223502{col 58}   .68872{col 70}   .69095
{txt}{hline 9}{c +}{hline 68}
    diff {c |}{res}{col 22}-.1023121{col 34} .0013463{col 58}-.1049507{col 70}-.0996735
{txt}{hline 9}{c BT}{hline 68}
    diff = mean({res}1{txt}) - mean({res}0{txt})                                      t = {res}-75.9978
{txt}H0: diff = 0                     Satterthwaite's degrees of freedom = {res}  418012

    {txt}Ha: diff < 0                 Ha: diff != 0                 Ha: diff > 0
 Pr(T < t) = {res}0.0000         {txt}Pr(|T| > |t|) = {res}0.0000          {txt}Pr(T > t) = {res}1.0000
{txt}
{com}. 
. ** UPPER TERCILE MINORITY RELATIVE SGPDs [ln_ratio_mnmsup_mnmsub >= -0.286034494638443] **
. ttest lndiversity2zeroadj if ln_ratio_mnmsup_mnmsub >= -0.286034494638443, by(minority) unequal  reverse

{txt}Two-sample t test with unequal variances
{hline 9}{c TT}{hline 68}
   Group{col 10}{c |}{col 16}Obs{col 27}Mean{col 35}Std. err.{col 47}Std. dev.{col 59}[95% conf. interval]
{hline 9}{c +}{hline 68}
       1 {c |}{res}{col 12}312,700{col 22} .5951771{col 34} .0011237{col 46} .6283539{col 58} .5929747{col 70} .5973795
       {txt}0 {c |}{res}{col 12}523,288{col 22} .7068758{col 34}  .000654{col 46} .4731059{col 58}  .705594{col 70} .7081577
{txt}{hline 9}{c +}{hline 68}
Combined {c |}{res}{col 12}835,988{col 22} .6650951{col 34} .0005897{col 46} .5391772{col 58} .6639393{col 70} .6662509
{txt}{hline 9}{c +}{hline 68}
    diff {c |}{res}{col 22}-.1116987{col 34} .0013001{col 58}-.1142469{col 70}-.1091505
{txt}{hline 9}{c BT}{hline 68}
    diff = mean({res}1{txt}) - mean({res}0{txt})                                      t = {res}-85.9124
{txt}H0: diff = 0                     Satterthwaite's degrees of freedom = {res}  524479

    {txt}Ha: diff < 0                 Ha: diff != 0                 Ha: diff > 0
 Pr(T < t) = {res}0.0000         {txt}Pr(|T| > |t|) = {res}0.0000          {txt}Pr(T > t) = {res}1.0000
{txt}
{com}. 
. 
. 
. 
. 
. ************** BROKEN DOWN BY NON-SUPERVISORY RESPONDENTS AND SUPERVISORY RESPONDENTS **************
. 
. 
. 
. 
. ************** NON-SUPERVISORY RESPONDENTS **************
. 
. 
. *** RACIAL/ETHNIC MINORITY versus RACIAL/ETHNIC NON-MINORITY Respondent Differences: Relative SGPDs  [AUTHORITY DIFFERENTIALS -- SEE EQUATION (1)]***
. 
. 
. 
. ** LOWER TERCILE MINORITY RELATIVE SGPDs [ln_ratio_mnmsup_mnmsub < -0.3859817981719971] ** 
. ttest lndiversity2zeroadj if ln_ratio_mnmsup_mnmsub < -0.3859817981719971 & supervisor == 0, by(minority) unequal  reverse

{txt}Two-sample t test with unequal variances
{hline 9}{c TT}{hline 68}
   Group{col 10}{c |}{col 16}Obs{col 27}Mean{col 35}Std. err.{col 47}Std. dev.{col 59}[95% conf. interval]
{hline 9}{c +}{hline 68}
       1 {c |}{res}{col 12}221,921{col 22} .5891267{col 34} .0013612{col 46} .6412471{col 58} .5864587{col 70} .5917946
       {txt}0 {c |}{res}{col 12}398,691{col 22} .7019786{col 34} .0007558{col 46} .4772444{col 58} .7004972{col 70}   .70346
{txt}{hline 9}{c +}{hline 68}
Combined {c |}{res}{col 12}620,612{col 22} .6616246{col 34} .0006909{col 46} .5443169{col 58} .6602703{col 70} .6629788
{txt}{hline 9}{c +}{hline 68}
    diff {c |}{res}{col 22} -.112852{col 34}  .001557{col 58}-.1159036{col 70}-.1098003
{txt}{hline 9}{c BT}{hline 68}
    diff = mean({res}1{txt}) - mean({res}0{txt})                                      t = {res}-72.4815
{txt}H0: diff = 0                     Satterthwaite's degrees of freedom = {res}  360768

    {txt}Ha: diff < 0                 Ha: diff != 0                 Ha: diff > 0
 Pr(T < t) = {res}0.0000         {txt}Pr(|T| > |t|) = {res}0.0000          {txt}Pr(T > t) = {res}1.0000
{txt}
{com}. 
. ** MIDDLE TERCILE MINORITY RELATIVE SGPDs [ln_ratio_mnmsup_mnmsub >= -.3838399 & ln_ratio_mnmsup_mnmsub < -0.286034494638443] ** 
. ttest lndiversity2zeroadj if ln_ratio_mnmsup_mnmsub >= -0.3859817981719971 & ln_ratio_mnmsup_mnmsub < -0.286034494638443 & supervisor == 0, by(minority) unequal  reverse

{txt}Two-sample t test with unequal variances
{hline 9}{c TT}{hline 68}
   Group{col 10}{c |}{col 16}Obs{col 27}Mean{col 35}Std. err.{col 47}Std. dev.{col 59}[95% conf. interval]
{hline 9}{c +}{hline 68}
       1 {c |}{res}{col 12}220,402{col 22}  .599123{col 34} .0013773{col 46} .6466004{col 58} .5964235{col 70} .6018224
       {txt}0 {c |}{res}{col 12}426,854{col 22} .6936398{col 34} .0007461{col 46} .4874672{col 58} .6921774{col 70} .6951021
{txt}{hline 9}{c +}{hline 68}
Combined {c |}{res}{col 12}647,256{col 22} .6614552{col 34}  .000682{col 46} .5487097{col 58} .6601184{col 70} .6627919
{txt}{hline 9}{c +}{hline 68}
    diff {c |}{res}{col 22}-.0945168{col 34} .0015664{col 58}-.0975869{col 70}-.0914467
{txt}{hline 9}{c BT}{hline 68}
    diff = mean({res}1{txt}) - mean({res}0{txt})                                      t = {res}-60.3398
{txt}H0: diff = 0                     Satterthwaite's degrees of freedom = {res}  353043

    {txt}Ha: diff < 0                 Ha: diff != 0                 Ha: diff > 0
 Pr(T < t) = {res}0.0000         {txt}Pr(|T| > |t|) = {res}0.0000          {txt}Pr(T > t) = {res}1.0000
{txt}
{com}. 
. ** UPPER TERCILE MINORITY RELATIVE SGPDs [ln_ratio_mnmsup_mnmsub >= -0.286034494638443] **
. ttest lndiversity2zeroadj if ln_ratio_mnmsup_mnmsub >= -0.286034494638443 & supervisor == 0, by(minority) unequal  reverse

{txt}Two-sample t test with unequal variances
{hline 9}{c TT}{hline 68}
   Group{col 10}{c |}{col 16}Obs{col 27}Mean{col 35}Std. err.{col 47}Std. dev.{col 59}[95% conf. interval]
{hline 9}{c +}{hline 68}
       1 {c |}{res}{col 12}243,807{col 22} .5639985{col 34} .0013276{col 46} .6555412{col 58} .5613964{col 70} .5666007
       {txt}0 {c |}{res}{col 12}383,773{col 22} .6733023{col 34} .0008113{col 46} .5025707{col 58} .6717122{col 70} .6748923
{txt}{hline 9}{c +}{hline 68}
Combined {c |}{res}{col 12}627,580{col 22} .6308391{col 34} .0007188{col 46} .5694192{col 58} .6294303{col 70} .6322479
{txt}{hline 9}{c +}{hline 68}
    diff {c |}{res}{col 22}-.1093037{col 34} .0015559{col 58}-.1123532{col 70}-.1062543
{txt}{hline 9}{c BT}{hline 68}
    diff = mean({res}1{txt}) - mean({res}0{txt})                                      t = {res}-70.2523
{txt}H0: diff = 0                     Satterthwaite's degrees of freedom = {res}  422451

    {txt}Ha: diff < 0                 Ha: diff != 0                 Ha: diff > 0
 Pr(T < t) = {res}0.0000         {txt}Pr(|T| > |t|) = {res}0.0000          {txt}Pr(T > t) = {res}1.0000
{txt}
{com}. 
. 
. 
. 
. ************** SUPERVISOR RESPONDENTS **************
. 
. 
. 
. *** RACIAL/ETHNIC MINORITY versus RACIAL/ETHNIC NON-MINORITY Respondent Differences: Relative SGPDs [AUTHORITY DIFFERENTIALS -- SEE EQUATION (1)]***
. 
. 
. ** LOWER TERCILE MINORITY RELATIVE SGPDs [ln_ratio_mnmsup_mnmsub < -0.3859817981719971] ** 
. ttest lndiversity2zeroadj if ln_ratio_mnmsup_mnmsub < -0.3859817981719971 & supervisor == 1, by(minority) unequal  reverse

{txt}Two-sample t test with unequal variances
{hline 9}{c TT}{hline 68}
   Group{col 10}{c |}{col 16}Obs{col 27}Mean{col 35}Std. err.{col 47}Std. dev.{col 59}[95% conf. interval]
{hline 9}{c +}{hline 68}
       1 {c |}{res}{col 12} 51,062{col 22} .7138754{col 34} .0022334{col 46} .5046803{col 58} .7094979{col 70} .7182529
       {txt}0 {c |}{res}{col 12}156,363{col 22} .8277046{col 34} .0008524{col 46} .3370695{col 58} .8260339{col 70} .8293754
{txt}{hline 9}{c +}{hline 68}
Combined {c |}{res}{col 12}207,425{col 22} .7996832{col 34} .0008525{col 46} .3882662{col 58} .7980123{col 70} .8013541
{txt}{hline 9}{c +}{hline 68}
    diff {c |}{res}{col 22}-.1138293{col 34} .0023905{col 58}-.1185147{col 70}-.1091438
{txt}{hline 9}{c BT}{hline 68}
    diff = mean({res}1{txt}) - mean({res}0{txt})                                      t = {res}-47.6164
{txt}H0: diff = 0                     Satterthwaite's degrees of freedom = {res} 66559.4

    {txt}Ha: diff < 0                 Ha: diff != 0                 Ha: diff > 0
 Pr(T < t) = {res}0.0000         {txt}Pr(|T| > |t|) = {res}0.0000          {txt}Pr(T > t) = {res}1.0000
{txt}
{com}. 
. ** MIDDLE TERCILE MINORITY RELATIVE SGPDs [ln_ratio_mnmsup_mnmsub >= -0.3859817981719971 & ln_ratio_mnmsup_mnmsub < -0.286034494638443] ** 
. ttest lndiversity2zeroadj if ln_ratio_mnmsup_mnmsub >= -0.3859817981719971 & ln_ratio_mnmsup_mnmsub < -0.286034494638443 & supervisor == 1, by(minority) unequal  reverse

{txt}Two-sample t test with unequal variances
{hline 9}{c TT}{hline 68}
   Group{col 10}{c |}{col 16}Obs{col 27}Mean{col 35}Std. err.{col 47}Std. dev.{col 59}[95% conf. interval]
{hline 9}{c +}{hline 68}
       1 {c |}{res}{col 12} 51,872{col 22} .7116703{col 34} .0022864{col 46} .5207329{col 58} .7071889{col 70} .7161516
       {txt}0 {c |}{res}{col 12}143,950{col 22} .8095736{col 34} .0009444{col 46} .3583089{col 58} .8077226{col 70} .8114246
{txt}{hline 9}{c +}{hline 68}
Combined {c |}{res}{col 12}195,822{col 22} .7836396{col 34} .0009264{col 46} .4099651{col 58} .7818238{col 70} .7854554
{txt}{hline 9}{c +}{hline 68}
    diff {c |}{res}{col 22}-.0979033{col 34} .0024737{col 58}-.1027519{col 70}-.0930548
{txt}{hline 9}{c BT}{hline 68}
    diff = mean({res}1{txt}) - mean({res}0{txt})                                      t = {res}-39.5770
{txt}H0: diff = 0                     Satterthwaite's degrees of freedom = {res} 70342.6

    {txt}Ha: diff < 0                 Ha: diff != 0                 Ha: diff > 0
 Pr(T < t) = {res}0.0000         {txt}Pr(|T| > |t|) = {res}0.0000          {txt}Pr(T > t) = {res}1.0000
{txt}
{com}. 
. ** UPPER TERCILE MINORITY RELATIVE SGPDs [ln_ratio_mnmsup_mnmsub >= -0.286034494638443] **
. ttest lndiversity2zeroadj if ln_ratio_mnmsup_mnmsub >= -0.286034494638443 & supervisor == 1, by(minority) unequal  reverse

{txt}Two-sample t test with unequal variances
{hline 9}{c TT}{hline 68}
   Group{col 10}{c |}{col 16}Obs{col 27}Mean{col 35}Std. err.{col 47}Std. dev.{col 59}[95% conf. interval]
{hline 9}{c +}{hline 68}
       1 {c |}{res}{col 12} 68,893{col 22} .7055157{col 34} .0019265{col 46} .5056577{col 58} .7017398{col 70} .7092916
       {txt}0 {c |}{res}{col 12}139,515{col 22} .7992288{col 34} .0009768{col 46} .3648579{col 58} .7973142{col 70} .8011433
{txt}{hline 9}{c +}{hline 68}
Combined {c |}{res}{col 12}208,408{col 22} .7682502{col 34} .0009179{col 46} .4190237{col 58} .7664512{col 70} .7700492
{txt}{hline 9}{c +}{hline 68}
    diff {c |}{res}{col 22}-.0937131{col 34}   .00216{col 58}-.0979466{col 70}-.0894795
{txt}{hline 9}{c BT}{hline 68}
    diff = mean({res}1{txt}) - mean({res}0{txt})                                      t = {res}-43.3858
{txt}H0: diff = 0                     Satterthwaite's degrees of freedom = {res}  105428

    {txt}Ha: diff < 0                 Ha: diff != 0                 Ha: diff > 0
 Pr(T < t) = {res}0.0000         {txt}Pr(|T| > |t|) = {res}0.0000          {txt}Pr(T > t) = {res}1.0000
{txt}
{com}. 
. 
. 
. 
. ************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************************
. 
. 
. log close
      {txt}name:  {res}<unnamed>
       {txt}log:  {res}C:\Users\gk57526\Dropbox\DISCRIMINATION PROJECT (U.S. FEDERAL AGENCIES)\Organizational Diversity & Formal Complaints Project\Statistics\Krause & Park.Authority Differentials.APPENDIX J RESULTS.11-24-2023.smcl
  {txt}log type:  {res}smcl
 {txt}closed on:  {res}24 Nov 2023, 17:30:38
{txt}{.-}
{smcl}
{txt}{sf}{ul off}